{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import json\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "30936\n"
     ]
    }
   ],
   "source": [
    "tweets_data_path = 'E:\\\\Desktop2\\\\tweets.txt'\n",
    "\n",
    "tweets_data = []\n",
    "tweets_file = open(tweets_data_path, \"r\")\n",
    "for line in tweets_file:\n",
    "    try:\n",
    "        tweet = json.loads(line)\n",
    "        tweets_data.append((tweet[\"user\"][\"id\"],tweet[\"text\"],tweet['retweeted_status'][\"retweet_count\"],tweet['retweeted_status']['reply_count'],tweet[\"user\"][\"friends_count\"],tweet[\"user\"][\"listed_count\"],tweet[\"user\"][\"favourites_count\"],tweet[\"user\"][\"statuses_count\"],tweet[\"user\"][\"followers_count\"]))\n",
    "        #print(tweet[\"user\"])\n",
    "    except:\n",
    "        continue\n",
    "        \n",
    "print(len(tweets_data))\n",
    "#followers_count\":586,\"friends_count\":308,\"listed_count\":203,\"favourites_count\":6555,\"statuses_count\":96502\n",
    "#,tweet[\"friends_count\"],tweet[\"listed_count\"],tweet[\"favourites_count\"],tweet[\"statuses_count\"],tweet[\"followers_count\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(586724399,\n",
       " 'RT @LizCrokin: Hillary Clinton is going to jail. That’s all. \\n\\n#QAnon #wwg1wga #thegreatawakening #greatawakening #pizzagate #Pedogate \\nhtt…',\n",
       " 128,\n",
       " 44,\n",
       " 308,\n",
       " 203,\n",
       " 6555,\n",
       " 96502,\n",
       " 586)"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tweets_data[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "import io\n",
    "file2write=open(\"E:\\\\Desktop2\\\\tweet_with_count.csv\",'w',encoding=\"utf-8\")\n",
    "#file2write.write(str(tweets_data))\n",
    "#file2write.close()\n",
    "for i in range(len(tweets_data)):\n",
    "    file2write.write(str(tweets_data[i]))\n",
    "file2write.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "data=pd.DataFrame(tweets_data,columns=[\"ID\",\"text\",\"retweet_count\",\"reply_count\",\"Friends_count\",\"Listed_count\",\"Fav_count\",\"Status_count\",\"Followers_count\"])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Count Extraction"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>text</th>\n",
       "      <th>retweet_count</th>\n",
       "      <th>reply_count</th>\n",
       "      <th>Friends_count</th>\n",
       "      <th>Listed_count</th>\n",
       "      <th>Fav_count</th>\n",
       "      <th>Status_count</th>\n",
       "      <th>Followers_count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>586724399</td>\n",
       "      <td>RT @LizCrokin: Hillary Clinton is going to jai...</td>\n",
       "      <td>128</td>\n",
       "      <td>44</td>\n",
       "      <td>308</td>\n",
       "      <td>203</td>\n",
       "      <td>6555</td>\n",
       "      <td>96502</td>\n",
       "      <td>586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>321589716</td>\n",
       "      <td>RT @lauferlaw: “Russia, if you’re listening, I...</td>\n",
       "      <td>276</td>\n",
       "      <td>25</td>\n",
       "      <td>1382</td>\n",
       "      <td>2</td>\n",
       "      <td>34208</td>\n",
       "      <td>35442</td>\n",
       "      <td>332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2774138510</td>\n",
       "      <td>RT @ChuckRossDC: Was Don Jr. expecting Hillary...</td>\n",
       "      <td>162</td>\n",
       "      <td>39</td>\n",
       "      <td>614</td>\n",
       "      <td>0</td>\n",
       "      <td>5222</td>\n",
       "      <td>9424</td>\n",
       "      <td>95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1064463919</td>\n",
       "      <td>RT @krassenstein: Trump just tweeted \"Hillary ...</td>\n",
       "      <td>2701</td>\n",
       "      <td>793</td>\n",
       "      <td>1078</td>\n",
       "      <td>0</td>\n",
       "      <td>7762</td>\n",
       "      <td>5194</td>\n",
       "      <td>146</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>778446398</td>\n",
       "      <td>RT @chuckwoolery: 2018 Losses Pile Up For The ...</td>\n",
       "      <td>54</td>\n",
       "      <td>18</td>\n",
       "      <td>80</td>\n",
       "      <td>0</td>\n",
       "      <td>17420</td>\n",
       "      <td>12959</td>\n",
       "      <td>73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>705770005636321280</td>\n",
       "      <td>RT @realDonaldTrump: “There has been no eviden...</td>\n",
       "      <td>14511</td>\n",
       "      <td>22831</td>\n",
       "      <td>17900</td>\n",
       "      <td>45</td>\n",
       "      <td>92264</td>\n",
       "      <td>53567</td>\n",
       "      <td>16612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>538455539</td>\n",
       "      <td>RT @BestRDSP: The history with Clinton and the...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>10064</td>\n",
       "      <td>216</td>\n",
       "      <td>67534</td>\n",
       "      <td>128828</td>\n",
       "      <td>9364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>982752402544648192</td>\n",
       "      <td>RT @nuzombie4: @auroravoyager1 @seanhannity WH...</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>4861</td>\n",
       "      <td>0</td>\n",
       "      <td>4428</td>\n",
       "      <td>14841</td>\n",
       "      <td>3347</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>3227495570</td>\n",
       "      <td>RT @davidsirota: Turned on my phone this morni...</td>\n",
       "      <td>24</td>\n",
       "      <td>7</td>\n",
       "      <td>350</td>\n",
       "      <td>131</td>\n",
       "      <td>49094</td>\n",
       "      <td>62457</td>\n",
       "      <td>513</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>4797024615</td>\n",
       "      <td>RT @ChrisJZullo: I’ve identified 23 Republican...</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>1182</td>\n",
       "      <td>28</td>\n",
       "      <td>24096</td>\n",
       "      <td>6753</td>\n",
       "      <td>765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>838592179262144512</td>\n",
       "      <td>RT @realDonaldTrump: “There has been no eviden...</td>\n",
       "      <td>14512</td>\n",
       "      <td>22838</td>\n",
       "      <td>1984</td>\n",
       "      <td>19</td>\n",
       "      <td>23723</td>\n",
       "      <td>20510</td>\n",
       "      <td>1587</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>870071720731828224</td>\n",
       "      <td>RT @KaivanShroff: MEDIA BIAS: Democratic Socia...</td>\n",
       "      <td>139</td>\n",
       "      <td>19</td>\n",
       "      <td>247</td>\n",
       "      <td>1</td>\n",
       "      <td>10115</td>\n",
       "      <td>6294</td>\n",
       "      <td>319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>918169251877236736</td>\n",
       "      <td>RT @TKarikala: நாம் தமிழர் திமு காந்தி தமிழனே ...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1199</td>\n",
       "      <td>0</td>\n",
       "      <td>1765</td>\n",
       "      <td>232</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>830892828926500864</td>\n",
       "      <td>RT @kylegriffin1: Trump has spent nearly 1 in ...</td>\n",
       "      <td>1955</td>\n",
       "      <td>291</td>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>2910</td>\n",
       "      <td>4318</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>424359321</td>\n",
       "      <td>RT @LizCrokin: Hillary Clinton is going to jai...</td>\n",
       "      <td>129</td>\n",
       "      <td>44</td>\n",
       "      <td>4999</td>\n",
       "      <td>7</td>\n",
       "      <td>30120</td>\n",
       "      <td>21472</td>\n",
       "      <td>4480</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>747624860</td>\n",
       "      <td>RT @LizCrokin: Hillary Clinton is going to jai...</td>\n",
       "      <td>130</td>\n",
       "      <td>44</td>\n",
       "      <td>2069</td>\n",
       "      <td>3</td>\n",
       "      <td>12703</td>\n",
       "      <td>10488</td>\n",
       "      <td>1315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>3061081969</td>\n",
       "      <td>RT @realDonaldTrump: “There has been no eviden...</td>\n",
       "      <td>14513</td>\n",
       "      <td>22835</td>\n",
       "      <td>64</td>\n",
       "      <td>0</td>\n",
       "      <td>159</td>\n",
       "      <td>210</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1084586538</td>\n",
       "      <td>RT @Danderup21: Is that all you got? The Daily...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>4377</td>\n",
       "      <td>5</td>\n",
       "      <td>61822</td>\n",
       "      <td>45673</td>\n",
       "      <td>2912</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>854271564</td>\n",
       "      <td>RT @realDonaldTrump: “There has been no eviden...</td>\n",
       "      <td>14514</td>\n",
       "      <td>22840</td>\n",
       "      <td>547</td>\n",
       "      <td>3</td>\n",
       "      <td>10121</td>\n",
       "      <td>7961</td>\n",
       "      <td>571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>243275901</td>\n",
       "      <td>RT @KimDotcom: I certainly know that Wikileaks...</td>\n",
       "      <td>2823</td>\n",
       "      <td>163</td>\n",
       "      <td>687</td>\n",
       "      <td>36</td>\n",
       "      <td>5265</td>\n",
       "      <td>24594</td>\n",
       "      <td>497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>154985912</td>\n",
       "      <td>RT @carterforva: 3 years ago the story was \"A ...</td>\n",
       "      <td>331</td>\n",
       "      <td>32</td>\n",
       "      <td>180</td>\n",
       "      <td>102</td>\n",
       "      <td>267</td>\n",
       "      <td>36379</td>\n",
       "      <td>312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>3111889034</td>\n",
       "      <td>RT @BrianKarem: Makes sense. The Democrats col...</td>\n",
       "      <td>103</td>\n",
       "      <td>32</td>\n",
       "      <td>7219</td>\n",
       "      <td>89</td>\n",
       "      <td>178991</td>\n",
       "      <td>167532</td>\n",
       "      <td>6992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>790607081476730880</td>\n",
       "      <td>RT @DineshDSouza: WATCH: The Nazi 25-point pla...</td>\n",
       "      <td>1421</td>\n",
       "      <td>229</td>\n",
       "      <td>109</td>\n",
       "      <td>2</td>\n",
       "      <td>21907</td>\n",
       "      <td>7570</td>\n",
       "      <td>211</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>63170544</td>\n",
       "      <td>RT @SavingAmerica4U: 🔴WATCH: Video of Bernie S...</td>\n",
       "      <td>116</td>\n",
       "      <td>7</td>\n",
       "      <td>204</td>\n",
       "      <td>55</td>\n",
       "      <td>203175</td>\n",
       "      <td>263303</td>\n",
       "      <td>1567</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>10350652</td>\n",
       "      <td>RT @DavidCornDC: Your son, son-in-law, and cam...</td>\n",
       "      <td>977</td>\n",
       "      <td>127</td>\n",
       "      <td>1894</td>\n",
       "      <td>172</td>\n",
       "      <td>12569</td>\n",
       "      <td>198902</td>\n",
       "      <td>1628</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>143072667</td>\n",
       "      <td>RT @Swamy39: Like in Sterlite agitation, the E...</td>\n",
       "      <td>1469</td>\n",
       "      <td>250</td>\n",
       "      <td>1776</td>\n",
       "      <td>17</td>\n",
       "      <td>35344</td>\n",
       "      <td>42910</td>\n",
       "      <td>1723</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>3231061942</td>\n",
       "      <td>RT @United4TrumpUSA: .@Ocasio2018 Bernie Sande...</td>\n",
       "      <td>123</td>\n",
       "      <td>29</td>\n",
       "      <td>5322</td>\n",
       "      <td>43</td>\n",
       "      <td>8507</td>\n",
       "      <td>35462</td>\n",
       "      <td>5147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>426321629</td>\n",
       "      <td>RT @LizCrokin: Hillary Clinton is going to jai...</td>\n",
       "      <td>131</td>\n",
       "      <td>45</td>\n",
       "      <td>6966</td>\n",
       "      <td>36</td>\n",
       "      <td>19685</td>\n",
       "      <td>33469</td>\n",
       "      <td>6391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1646300622</td>\n",
       "      <td>RT @_L_o_r_i_: I'm evidence\\nI'm not Russian\\n...</td>\n",
       "      <td>49</td>\n",
       "      <td>5</td>\n",
       "      <td>10404</td>\n",
       "      <td>6</td>\n",
       "      <td>60551</td>\n",
       "      <td>38207</td>\n",
       "      <td>10150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>822550313676763138</td>\n",
       "      <td>RT @mitchellvii: #SlowWalker is coming folks. ...</td>\n",
       "      <td>324</td>\n",
       "      <td>34</td>\n",
       "      <td>4749</td>\n",
       "      <td>17</td>\n",
       "      <td>6283</td>\n",
       "      <td>29358</td>\n",
       "      <td>3196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30906</th>\n",
       "      <td>998110604656300032</td>\n",
       "      <td>RT @JudicialWatch: JW's court battles forced t...</td>\n",
       "      <td>217</td>\n",
       "      <td>29</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>959</td>\n",
       "      <td>734</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30907</th>\n",
       "      <td>76539248</td>\n",
       "      <td>RT @ImATrumplican: Remember when Hillary Clint...</td>\n",
       "      <td>40</td>\n",
       "      <td>2</td>\n",
       "      <td>488</td>\n",
       "      <td>1</td>\n",
       "      <td>2351</td>\n",
       "      <td>1376</td>\n",
       "      <td>206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30908</th>\n",
       "      <td>1026316679922556933</td>\n",
       "      <td>RT @jwheels74: Dumbass “@realDonaldTrump shoul...</td>\n",
       "      <td>27</td>\n",
       "      <td>5</td>\n",
       "      <td>90</td>\n",
       "      <td>0</td>\n",
       "      <td>178</td>\n",
       "      <td>105</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30909</th>\n",
       "      <td>330075517</td>\n",
       "      <td>RT @WriteSmitty: Giuliani (late October 2016):...</td>\n",
       "      <td>653</td>\n",
       "      <td>38</td>\n",
       "      <td>145</td>\n",
       "      <td>1</td>\n",
       "      <td>26026</td>\n",
       "      <td>22114</td>\n",
       "      <td>70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30910</th>\n",
       "      <td>91994358</td>\n",
       "      <td>RT @realDonaldTrump: “There has been no eviden...</td>\n",
       "      <td>20566</td>\n",
       "      <td>30150</td>\n",
       "      <td>3897</td>\n",
       "      <td>31</td>\n",
       "      <td>14308</td>\n",
       "      <td>8785</td>\n",
       "      <td>3893</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30911</th>\n",
       "      <td>464325909</td>\n",
       "      <td>RT @krassenstein: Hillary Clinton testified fo...</td>\n",
       "      <td>2315</td>\n",
       "      <td>417</td>\n",
       "      <td>61</td>\n",
       "      <td>0</td>\n",
       "      <td>624</td>\n",
       "      <td>508</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30912</th>\n",
       "      <td>4138545078</td>\n",
       "      <td>RT @NaamTamilarOrg: பெங்களூரில் கைதுசெய்யப்பட்...</td>\n",
       "      <td>149</td>\n",
       "      <td>10</td>\n",
       "      <td>68</td>\n",
       "      <td>0</td>\n",
       "      <td>7170</td>\n",
       "      <td>3372</td>\n",
       "      <td>162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30913</th>\n",
       "      <td>408908972</td>\n",
       "      <td>RT @JackPosobiec: I’m told that the GOP operat...</td>\n",
       "      <td>584</td>\n",
       "      <td>102</td>\n",
       "      <td>1299</td>\n",
       "      <td>0</td>\n",
       "      <td>72006</td>\n",
       "      <td>12017</td>\n",
       "      <td>1396</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30914</th>\n",
       "      <td>2746541138</td>\n",
       "      <td>RT @lynnv378: These same mutha fuckas calling ...</td>\n",
       "      <td>74</td>\n",
       "      <td>19</td>\n",
       "      <td>1374</td>\n",
       "      <td>87</td>\n",
       "      <td>274577</td>\n",
       "      <td>121160</td>\n",
       "      <td>1138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30915</th>\n",
       "      <td>16672654</td>\n",
       "      <td>RT @stevendeknight: That’s quite an evil plan ...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>551</td>\n",
       "      <td>16</td>\n",
       "      <td>36153</td>\n",
       "      <td>42349</td>\n",
       "      <td>443</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30916</th>\n",
       "      <td>4374944129</td>\n",
       "      <td>RT @krassenstein: Hillary Clinton testified fo...</td>\n",
       "      <td>2316</td>\n",
       "      <td>417</td>\n",
       "      <td>803</td>\n",
       "      <td>3</td>\n",
       "      <td>66574</td>\n",
       "      <td>57383</td>\n",
       "      <td>750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30917</th>\n",
       "      <td>825075427693752320</td>\n",
       "      <td>RT @USANEWS007: BREAKING: CONSPIRACY TO ENTRAP...</td>\n",
       "      <td>189</td>\n",
       "      <td>9</td>\n",
       "      <td>80</td>\n",
       "      <td>0</td>\n",
       "      <td>13484</td>\n",
       "      <td>4589</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30918</th>\n",
       "      <td>244826844</td>\n",
       "      <td>RT @realDonaldTrump: “There has been no eviden...</td>\n",
       "      <td>20567</td>\n",
       "      <td>30150</td>\n",
       "      <td>4478</td>\n",
       "      <td>80</td>\n",
       "      <td>38229</td>\n",
       "      <td>44689</td>\n",
       "      <td>3787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30919</th>\n",
       "      <td>924106461013299200</td>\n",
       "      <td>RT @CREWcrew: Almost $56K in taxpayer money ha...</td>\n",
       "      <td>295</td>\n",
       "      <td>12</td>\n",
       "      <td>66</td>\n",
       "      <td>0</td>\n",
       "      <td>28537</td>\n",
       "      <td>9056</td>\n",
       "      <td>134</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30920</th>\n",
       "      <td>996558327491555328</td>\n",
       "      <td>RT @krassenstein: Hillary Clinton testified fo...</td>\n",
       "      <td>2317</td>\n",
       "      <td>417</td>\n",
       "      <td>584</td>\n",
       "      <td>0</td>\n",
       "      <td>21053</td>\n",
       "      <td>9736</td>\n",
       "      <td>404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30921</th>\n",
       "      <td>724401635942789120</td>\n",
       "      <td>RT @krassenstein: Hillary Clinton testified fo...</td>\n",
       "      <td>2318</td>\n",
       "      <td>417</td>\n",
       "      <td>148</td>\n",
       "      <td>0</td>\n",
       "      <td>10661</td>\n",
       "      <td>2416</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30922</th>\n",
       "      <td>836716503357657089</td>\n",
       "      <td>RT @Bryan700: Hillary Clinton's inaugural crow...</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>861</td>\n",
       "      <td>2</td>\n",
       "      <td>3876</td>\n",
       "      <td>4639</td>\n",
       "      <td>318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30923</th>\n",
       "      <td>502332093</td>\n",
       "      <td>RT @OrenthalJackson: Its always been \"black\" &amp;...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>18875</td>\n",
       "      <td>87</td>\n",
       "      <td>32278</td>\n",
       "      <td>27320</td>\n",
       "      <td>17198</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30924</th>\n",
       "      <td>2608207172</td>\n",
       "      <td>RT @TheStagmania: Takes like this are 1) not t...</td>\n",
       "      <td>31</td>\n",
       "      <td>12</td>\n",
       "      <td>141</td>\n",
       "      <td>5</td>\n",
       "      <td>72918</td>\n",
       "      <td>37119</td>\n",
       "      <td>288</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30925</th>\n",
       "      <td>299878544</td>\n",
       "      <td>RT @gatewaypundit: GOP Activist Investigating ...</td>\n",
       "      <td>275</td>\n",
       "      <td>42</td>\n",
       "      <td>2730</td>\n",
       "      <td>3</td>\n",
       "      <td>46204</td>\n",
       "      <td>80885</td>\n",
       "      <td>2707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30926</th>\n",
       "      <td>2887004465</td>\n",
       "      <td>RT @jwheels74: Dumbass “@realDonaldTrump shoul...</td>\n",
       "      <td>28</td>\n",
       "      <td>5</td>\n",
       "      <td>4676</td>\n",
       "      <td>3</td>\n",
       "      <td>36772</td>\n",
       "      <td>20682</td>\n",
       "      <td>4525</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30927</th>\n",
       "      <td>520080465</td>\n",
       "      <td>RT @LizCrokin: Hillary Clinton is going to jai...</td>\n",
       "      <td>1510</td>\n",
       "      <td>297</td>\n",
       "      <td>10196</td>\n",
       "      <td>20</td>\n",
       "      <td>27258</td>\n",
       "      <td>35169</td>\n",
       "      <td>10493</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30928</th>\n",
       "      <td>34069014</td>\n",
       "      <td>RT @ToddHagopian: The very worst politicians i...</td>\n",
       "      <td>47</td>\n",
       "      <td>28</td>\n",
       "      <td>1426</td>\n",
       "      <td>49</td>\n",
       "      <td>36446</td>\n",
       "      <td>79719</td>\n",
       "      <td>1267</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30929</th>\n",
       "      <td>14261329</td>\n",
       "      <td>RT @MrDane1982: Hillary Clinton is still stand...</td>\n",
       "      <td>95</td>\n",
       "      <td>19</td>\n",
       "      <td>4406</td>\n",
       "      <td>221</td>\n",
       "      <td>14825</td>\n",
       "      <td>138329</td>\n",
       "      <td>2038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30930</th>\n",
       "      <td>4260554615</td>\n",
       "      <td>RT @Cdeeman123: 202-224-1700 this is the numbe...</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>10030</td>\n",
       "      <td>12</td>\n",
       "      <td>28896</td>\n",
       "      <td>37848</td>\n",
       "      <td>10105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30931</th>\n",
       "      <td>833183624522559488</td>\n",
       "      <td>RT @lbrot1: GOP Activist Investigating Hillary...</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>4273</td>\n",
       "      <td>4</td>\n",
       "      <td>42227</td>\n",
       "      <td>8554</td>\n",
       "      <td>4440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30932</th>\n",
       "      <td>24732827</td>\n",
       "      <td>RT @CREWcrew: That isn’t a question at this po...</td>\n",
       "      <td>70</td>\n",
       "      <td>1</td>\n",
       "      <td>1151</td>\n",
       "      <td>1</td>\n",
       "      <td>21566</td>\n",
       "      <td>21295</td>\n",
       "      <td>191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30933</th>\n",
       "      <td>2863785729</td>\n",
       "      <td>RT @jwheels74: Dumbass “@realDonaldTrump shoul...</td>\n",
       "      <td>29</td>\n",
       "      <td>5</td>\n",
       "      <td>1396</td>\n",
       "      <td>14</td>\n",
       "      <td>57008</td>\n",
       "      <td>25096</td>\n",
       "      <td>545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30934</th>\n",
       "      <td>18234412</td>\n",
       "      <td>RT @krassenstein: Hillary Clinton testified fo...</td>\n",
       "      <td>2319</td>\n",
       "      <td>417</td>\n",
       "      <td>2323</td>\n",
       "      <td>27</td>\n",
       "      <td>7320</td>\n",
       "      <td>21949</td>\n",
       "      <td>875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30935</th>\n",
       "      <td>975450898938855425</td>\n",
       "      <td>RT @NizWolf: Peter Smith Republican political ...</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>700</td>\n",
       "      <td>0</td>\n",
       "      <td>46</td>\n",
       "      <td>13866</td>\n",
       "      <td>642</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>30936 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        ID                                               text  \\\n",
       "0                586724399  RT @LizCrokin: Hillary Clinton is going to jai...   \n",
       "1                321589716  RT @lauferlaw: “Russia, if you’re listening, I...   \n",
       "2               2774138510  RT @ChuckRossDC: Was Don Jr. expecting Hillary...   \n",
       "3               1064463919  RT @krassenstein: Trump just tweeted \"Hillary ...   \n",
       "4                778446398  RT @chuckwoolery: 2018 Losses Pile Up For The ...   \n",
       "5       705770005636321280  RT @realDonaldTrump: “There has been no eviden...   \n",
       "6                538455539  RT @BestRDSP: The history with Clinton and the...   \n",
       "7       982752402544648192  RT @nuzombie4: @auroravoyager1 @seanhannity WH...   \n",
       "8               3227495570  RT @davidsirota: Turned on my phone this morni...   \n",
       "9               4797024615  RT @ChrisJZullo: I’ve identified 23 Republican...   \n",
       "10      838592179262144512  RT @realDonaldTrump: “There has been no eviden...   \n",
       "11      870071720731828224  RT @KaivanShroff: MEDIA BIAS: Democratic Socia...   \n",
       "12      918169251877236736  RT @TKarikala: நாம் தமிழர் திமு காந்தி தமிழனே ...   \n",
       "13      830892828926500864  RT @kylegriffin1: Trump has spent nearly 1 in ...   \n",
       "14               424359321  RT @LizCrokin: Hillary Clinton is going to jai...   \n",
       "15               747624860  RT @LizCrokin: Hillary Clinton is going to jai...   \n",
       "16              3061081969  RT @realDonaldTrump: “There has been no eviden...   \n",
       "17              1084586538  RT @Danderup21: Is that all you got? The Daily...   \n",
       "18               854271564  RT @realDonaldTrump: “There has been no eviden...   \n",
       "19               243275901  RT @KimDotcom: I certainly know that Wikileaks...   \n",
       "20               154985912  RT @carterforva: 3 years ago the story was \"A ...   \n",
       "21              3111889034  RT @BrianKarem: Makes sense. The Democrats col...   \n",
       "22      790607081476730880  RT @DineshDSouza: WATCH: The Nazi 25-point pla...   \n",
       "23                63170544  RT @SavingAmerica4U: 🔴WATCH: Video of Bernie S...   \n",
       "24                10350652  RT @DavidCornDC: Your son, son-in-law, and cam...   \n",
       "25               143072667  RT @Swamy39: Like in Sterlite agitation, the E...   \n",
       "26              3231061942  RT @United4TrumpUSA: .@Ocasio2018 Bernie Sande...   \n",
       "27               426321629  RT @LizCrokin: Hillary Clinton is going to jai...   \n",
       "28              1646300622  RT @_L_o_r_i_: I'm evidence\\nI'm not Russian\\n...   \n",
       "29      822550313676763138  RT @mitchellvii: #SlowWalker is coming folks. ...   \n",
       "...                    ...                                                ...   \n",
       "30906   998110604656300032  RT @JudicialWatch: JW's court battles forced t...   \n",
       "30907             76539248  RT @ImATrumplican: Remember when Hillary Clint...   \n",
       "30908  1026316679922556933  RT @jwheels74: Dumbass “@realDonaldTrump shoul...   \n",
       "30909            330075517  RT @WriteSmitty: Giuliani (late October 2016):...   \n",
       "30910             91994358  RT @realDonaldTrump: “There has been no eviden...   \n",
       "30911            464325909  RT @krassenstein: Hillary Clinton testified fo...   \n",
       "30912           4138545078  RT @NaamTamilarOrg: பெங்களூரில் கைதுசெய்யப்பட்...   \n",
       "30913            408908972  RT @JackPosobiec: I’m told that the GOP operat...   \n",
       "30914           2746541138  RT @lynnv378: These same mutha fuckas calling ...   \n",
       "30915             16672654  RT @stevendeknight: That’s quite an evil plan ...   \n",
       "30916           4374944129  RT @krassenstein: Hillary Clinton testified fo...   \n",
       "30917   825075427693752320  RT @USANEWS007: BREAKING: CONSPIRACY TO ENTRAP...   \n",
       "30918            244826844  RT @realDonaldTrump: “There has been no eviden...   \n",
       "30919   924106461013299200  RT @CREWcrew: Almost $56K in taxpayer money ha...   \n",
       "30920   996558327491555328  RT @krassenstein: Hillary Clinton testified fo...   \n",
       "30921   724401635942789120  RT @krassenstein: Hillary Clinton testified fo...   \n",
       "30922   836716503357657089  RT @Bryan700: Hillary Clinton's inaugural crow...   \n",
       "30923            502332093  RT @OrenthalJackson: Its always been \"black\" &...   \n",
       "30924           2608207172  RT @TheStagmania: Takes like this are 1) not t...   \n",
       "30925            299878544  RT @gatewaypundit: GOP Activist Investigating ...   \n",
       "30926           2887004465  RT @jwheels74: Dumbass “@realDonaldTrump shoul...   \n",
       "30927            520080465  RT @LizCrokin: Hillary Clinton is going to jai...   \n",
       "30928             34069014  RT @ToddHagopian: The very worst politicians i...   \n",
       "30929             14261329  RT @MrDane1982: Hillary Clinton is still stand...   \n",
       "30930           4260554615  RT @Cdeeman123: 202-224-1700 this is the numbe...   \n",
       "30931   833183624522559488  RT @lbrot1: GOP Activist Investigating Hillary...   \n",
       "30932             24732827  RT @CREWcrew: That isn’t a question at this po...   \n",
       "30933           2863785729  RT @jwheels74: Dumbass “@realDonaldTrump shoul...   \n",
       "30934             18234412  RT @krassenstein: Hillary Clinton testified fo...   \n",
       "30935   975450898938855425  RT @NizWolf: Peter Smith Republican political ...   \n",
       "\n",
       "       retweet_count  reply_count  Friends_count  Listed_count  Fav_count  \\\n",
       "0                128           44            308           203       6555   \n",
       "1                276           25           1382             2      34208   \n",
       "2                162           39            614             0       5222   \n",
       "3               2701          793           1078             0       7762   \n",
       "4                 54           18             80             0      17420   \n",
       "5              14511        22831          17900            45      92264   \n",
       "6                  1            0          10064           216      67534   \n",
       "7                  3            0           4861             0       4428   \n",
       "8                 24            7            350           131      49094   \n",
       "9                  3            1           1182            28      24096   \n",
       "10             14512        22838           1984            19      23723   \n",
       "11               139           19            247             1      10115   \n",
       "12                 1            0           1199             0       1765   \n",
       "13              1955          291             44             0       2910   \n",
       "14               129           44           4999             7      30120   \n",
       "15               130           44           2069             3      12703   \n",
       "16             14513        22835             64             0        159   \n",
       "17                 1            0           4377             5      61822   \n",
       "18             14514        22840            547             3      10121   \n",
       "19              2823          163            687            36       5265   \n",
       "20               331           32            180           102        267   \n",
       "21               103           32           7219            89     178991   \n",
       "22              1421          229            109             2      21907   \n",
       "23               116            7            204            55     203175   \n",
       "24               977          127           1894           172      12569   \n",
       "25              1469          250           1776            17      35344   \n",
       "26               123           29           5322            43       8507   \n",
       "27               131           45           6966            36      19685   \n",
       "28                49            5          10404             6      60551   \n",
       "29               324           34           4749            17       6283   \n",
       "...              ...          ...            ...           ...        ...   \n",
       "30906            217           29             40             0        959   \n",
       "30907             40            2            488             1       2351   \n",
       "30908             27            5             90             0        178   \n",
       "30909            653           38            145             1      26026   \n",
       "30910          20566        30150           3897            31      14308   \n",
       "30911           2315          417             61             0        624   \n",
       "30912            149           10             68             0       7170   \n",
       "30913            584          102           1299             0      72006   \n",
       "30914             74           19           1374            87     274577   \n",
       "30915              1            2            551            16      36153   \n",
       "30916           2316          417            803             3      66574   \n",
       "30917            189            9             80             0      13484   \n",
       "30918          20567        30150           4478            80      38229   \n",
       "30919            295           12             66             0      28537   \n",
       "30920           2317          417            584             0      21053   \n",
       "30921           2318          417            148             0      10661   \n",
       "30922              8            3            861             2       3876   \n",
       "30923              1            0          18875            87      32278   \n",
       "30924             31           12            141             5      72918   \n",
       "30925            275           42           2730             3      46204   \n",
       "30926             28            5           4676             3      36772   \n",
       "30927           1510          297          10196            20      27258   \n",
       "30928             47           28           1426            49      36446   \n",
       "30929             95           19           4406           221      14825   \n",
       "30930              8            2          10030            12      28896   \n",
       "30931              4            1           4273             4      42227   \n",
       "30932             70            1           1151             1      21566   \n",
       "30933             29            5           1396            14      57008   \n",
       "30934           2319          417           2323            27       7320   \n",
       "30935              6            1            700             0         46   \n",
       "\n",
       "       Status_count  Followers_count  \n",
       "0             96502              586  \n",
       "1             35442              332  \n",
       "2              9424               95  \n",
       "3              5194              146  \n",
       "4             12959               73  \n",
       "5             53567            16612  \n",
       "6            128828             9364  \n",
       "7             14841             3347  \n",
       "8             62457              513  \n",
       "9              6753              765  \n",
       "10            20510             1587  \n",
       "11             6294              319  \n",
       "12              232               61  \n",
       "13             4318               24  \n",
       "14            21472             4480  \n",
       "15            10488             1315  \n",
       "16              210               26  \n",
       "17            45673             2912  \n",
       "18             7961              571  \n",
       "19            24594              497  \n",
       "20            36379              312  \n",
       "21           167532             6992  \n",
       "22             7570              211  \n",
       "23           263303             1567  \n",
       "24           198902             1628  \n",
       "25            42910             1723  \n",
       "26            35462             5147  \n",
       "27            33469             6391  \n",
       "28            38207            10150  \n",
       "29            29358             3196  \n",
       "...             ...              ...  \n",
       "30906           734               15  \n",
       "30907          1376              206  \n",
       "30908           105               48  \n",
       "30909         22114               70  \n",
       "30910          8785             3893  \n",
       "30911           508               48  \n",
       "30912          3372              162  \n",
       "30913         12017             1396  \n",
       "30914        121160             1138  \n",
       "30915         42349              443  \n",
       "30916         57383              750  \n",
       "30917          4589               80  \n",
       "30918         44689             3787  \n",
       "30919          9056              134  \n",
       "30920          9736              404  \n",
       "30921          2416               26  \n",
       "30922          4639              318  \n",
       "30923         27320            17198  \n",
       "30924         37119              288  \n",
       "30925         80885             2707  \n",
       "30926         20682             4525  \n",
       "30927         35169            10493  \n",
       "30928         79719             1267  \n",
       "30929        138329             2038  \n",
       "30930         37848            10105  \n",
       "30931          8554             4440  \n",
       "30932         21295              191  \n",
       "30933         25096              545  \n",
       "30934         21949              875  \n",
       "30935         13866              642  \n",
       "\n",
       "[30936 rows x 9 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
